from sqlalchemy import Column, Integer, VARCHAR, TEXT
from models import Base


class MusicModel(Base):
    __tablename__ = 'music'
    id = Column(Integer, primary_key=True)
    song_mid = Column(VARCHAR(255))
    album_mid = Column(VARCHAR(255))
    singer_mid = Column(VARCHAR(255))
    song_name = Column(VARCHAR(255))
    singer_name = Column(VARCHAR(255), default='')
    album_name = Column(VARCHAR(255))
    song_url = Column(VARCHAR(255))
    my_song_url = Column(VARCHAR(255))
    song_info = Column(TEXT)
    state = Column(Integer)


class SingerModel(Base):
    __tablename__ = 'singer'
    id = Column(Integer, primary_key=True)
    singer_name = Column(VARCHAR(255))
    singer_mid = Column(VARCHAR(255))
    singer_pic = Column(VARCHAR(255))
    singer_country = Column(VARCHAR(255))

